CTDData_1993-2019SQLX Read Me

CTDData_1993-2019SQLX.bak is a SQL Server Express database backup. It was created using SQL Server Management Studio 20.
Please use SQL Server Management Studio 20 (or current version) to restore this database to SQL Server (Express).

This database was created using Microsoft SQL Server Migration Assistant for Access & DBeaver as 'phpMyadmin' for 
SQL Server Express. An Access database with upcast and downcast table structure and no data were migrated to
SQL Server Express. Using DBeaver, an upcast csv containing all the upcast station data from CalCOFI 9308NH to 1911NH
was imported into the upcast table. This step was repeated for the downcast data. 
This 1m bin-averaged CTD data database is ~4gb so be sure the server can handle these data.

Software used:
Microsoft Access 2021
Sql Server Express 2019
Microsoft SQL Server Migration Assistant for Access
SQL Server 2019 Configuration Manager
SQL Server Management Studio 20
DBeaver 24.1.2

Files:
9308NH-1911NH upcast & downcast finalQC combined station csvs.

James Wilkinson 07/11/2024
SIO-CalCOFI Technical Group